MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Equipment Rental & Usage (.txt) < prev next >

Wrap

FileMaker Pro Database | 1996-01-25 | 117KB | 866 lines

LZBovm9agm1cA/u3U499+TyGGjXtQpWvx4lnxg6ufZIoQqA6K0c8Q8Pz2HpNpRLFxycKpi588JJx 7R4BkCDMsLKet4DH78hwiyUWEtPHkXkyCRYyiDuoUhc2yVA0yw6O+CtcaC8UNVAksQLGpleEYDF1 nAiI4NBf88fiZfWmmBUZsdqGWnjPyGAykmnJc6SGjDwyKsmXfDIsPa1tVf8g7vRNLuOGJ5rgkFTF SAv95J0mF/7DvFhR7nqYqXBMoy01w8kGsfooJXgYHA5hLFZRws7UaLzBUBWzwGE0iplCGpsuAHks 6j/zx6pGprO/UUOIvFB+SpChyw2/rMCwT944j/TQUdJixmo54LESNU0KwzgdBnFRE86E0uaLRqJE Yj+1mN1sHETucnhS1RP305ylocKgPVKPmeiwAo9q1LhJHmx6cUQUm+5QeomZvJPjRAN4/g5nmtHR dwqcMJLnLCB42QUFDWDn5xWIc7z HBAM2016AUG95 Pro 3.0 kWyM+vGmgo HFhB1qkeP3liHSaNm8l6Y3xppFQxw2ABnkZHGSUodhkLQycRPOwh1yBED2+yFPYNZYKCy7BhnpFF 1Cb3eQZjFCkoBAARN70MA48t/N+PY8cM/v8VeIOEkhMxFFJlCI+/1QiBgpMMr+S9cwue7udzuJ31 WHSBDWHaSDEKN8MAehAVFmZlsHkccOob+fvk3RxWUnMKpCOHQzg1ptH1RbsyBbRIP8S/6RcLGI0X bXlCisuy8oUswSL1ecQja8aonILGDM1Hha2oD6cAMSlQqkgx2oHdg47Cdya5wioOI3tIkclnXEME BScEZMggg9dzjGMC8xllnmdUWuUHKC0jF4GzEJ4aUDSG0HJsh2KPjKXW1ZEJkEIa6wp0jaF52aQF hulIYXn1pxTYbAwEZ1A4yQ0PWO18wdCmosiFjGuIE1VWnFV156uFdey2YM0EDGkjLzwhZ4d I5QpD4wvNrITk hoKrTn3HJUMDMOWSY18sGti0KWrB/iAgtsB3g6cGQtP567mbShxpbmKVGnFU11h59usqZsumR51Z cdbRZXWRaSERgI6Raqgbua6J7qyhNCNLMhKw0iSeiBvSw1snplGPvrJRRgKmIJLMSy6Th0XD7PWX SMgJ8XiFGTEkn6E8yLNfi5BlvKe6M0WHc9THNEAU6qHAuYI0KBki87ned41j/Ae8Yka9lUVFCkmP GXUcUl54cWpl6hky0oha0MupA7TA+rAJ8INoYuc9Wz3PTl2HYiTMBEYjAA8CWPLF4xwih+FYUoHR I2yWfPAqE7OWhCNdFIzQLmRxO8OYtfQI+cMhU3qFJ+9FbethjtOjggK4MhN41SI1PztSfI0AiZIg TSjxVzCECNyHrJgR5YaHCmRZCT9KFopGNXZBwp1Kzo0y78jzLnLJqPrEFEmtQDOhwBElmQQvhTyp 10sgY0diQqQiCA1myMlKyEF5CMMuO2L5jP2RzlMDJiKvV7g6WpWbJlDTe/KziSNNnXUlrTJGbjgS HBAM3016AUG95@ Pro 2.0 - 2.1F! Pro 3.0 Franz App ASSET ID CATEGORY CREATED BY CUSTOMER ORDER NUM DATE CREATED DATE DUE DATE DUE CALC DATE END DATE END CALC DATE MODIFIED DATE START DATE START CALC DAYS OVERDUE DAYS RENTED DON'T COUNT WKNDS RECORD ID SERIAL NUMBER TODAY CALC TOTAL DAYS RENTED A Record IDB ItemB Date CreatedB Date ModifiedB Serial NumberB CategoryB Date DueB Date EndB Days RentedB Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 11/20/95 Date StartB Asset IDB Customer Order NumB Don't Count WkndsB Date End CalcB 7) = 0 " - 2 7) = 6 " - 1 "2222 Days OverdueB 3) / 7) * 5 + - 1904) < 1904) 2 0) ) ) ) 1 + 1 1 + 1) / 7) * 5 + - 1904) < 1904) 2 0) ) Date Start CalcB 7) = 0 ( + 1 7) = 6 ( + 2 Today CalcB 7) = 0 7) = 6 Date Due CalcB 7) = 0 ! + 1 7) = 6 ! + 2 Total Days RentedB InfoB Created ByB A Form View A List View Overdue Rentals Information Report Menu Accumulated Usage Rental History A Form ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Description This file helps you track rental equipment, such as furniture or computers. It keeps a rental history for each item. How to use this solution Use this solution to track current rentals and the rental history of each item. You can run reports detailing overdue rentals and the rental history of each piece. You can also use the reports to complete your taxes. How to customize this solution You can change the values in the predefined value list so that the report contains categor Bies for your types of rental equipment. You can link the Customer Order No. field to an Invoices database to complete your tracking system. Or, you can add a Customer ID field linked to a Customers database. Then you could create reports showing which rentals are current and which rentals are overdue for each customer. A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close I Today is: Days Rented Date of Rental End Days Overdue Date Due Customer Order No. Date of Rental Start Category Serial No. Asset ID Rental Rental X Enter data for Equipment Rentals Overdue RentalsB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter DaysV StartX Order No.Y ItemZ Asset ID[ Your Own Button\ Your Own Button] Record^ Delete Record_ Record` Reportsa View As Listb View As Formc Closed Infoe<Click to see more information for an Equipment Rental record InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Buttono Reportsp View As Listq View As Formr Closes Infot Days Overu Start Datev Order No.w Itemx Asset IDy Date Duez Page ## Your Own Buttono Reportsp View As Listq View As Formr Closes Infot Days Overu Start Datev Order No.w Itemx Asset IDy Date Duez Page ## |"Equipment Rentals; Overdue Rentals Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO/Information about the Equipment Rental solutionP Info for this Solution out the Equipment Rental solutionP Info for this Solution Your Own ReportB Rental HistoryC Accumulated UsageD Overdue RentalsE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report Accumulated UsageB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF Rental HistoryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Buttonp Reportsq View As Listr View As Forms Closet Infou Days Rentedv Itemw Asset IDx Page ##z$Equipment Rentals; Accumulated Usage Your Own Buttonp Reportsq View As Listr View As Forms Closet Infou Days Rentedv Itemw Asset IDx Page ##z$Equipment Rentals; Accumulated Usage Office ChairX 04/30/95Y 11/20/95_ 3343` Office Furnitureb 11/01/94e 05/03/94j 11/1/94o 5/3/94r 11/20/95 Office ChairX 04/30/95Y 11/20/95_ 3344` Office Furnitureb 11/01/94e 05/03/94j 11/1/94o 5/3/94r 11/20/95 Personal ComputerX 04/30/95Y 11/20/95_ 3939382` Computersa 06/04/94b 06/09/94e 05/04/94j 6/9/94o 5/4/94r 11/20/95s 6/4/94 Office ChairX 06/02/95Y 11/20/95_ 3343` Office Furnitureb 06/01/95e 11/02/94j 6/1/95o 11/2/94r 11/20/95 Office ChairX 06/02/95Y 11/20/95_ 3344` Office Furniturea 12/31/94e 11/08/94j 11/20/95o 11/8/94r 11/20/95s 12/31/94 Personal ComputerX 06/02/95Y 11/20/95_ 3939382` Computersa 09/04/94e 07/04/94j 11/20/95o 7/4/94r 11/20/95s 9/4/94 office furniture office furniture computers Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Buttonu Reportsv View As Listw View As Formx Closey Infoz Days{ End Date| Start Date} Order No.~ Asset ID, Item Category Page ## C!Equipment Rentals; Rental History ABCK>>, << ABAF>> Sort by Asset ID Sort by Item Sort by Customer Order Number Sort by Date of Rental Start Sort by Date of Rental End Sort for Rental History Overdue Rentals Accumulated Usage Rental History Open Script Sort by Asset ID Sort by Item Overdue Rentals Sort by Date of Rental Start Sort by Date of Rental End Sort by Customer Order Number Accumulated Usage Sort for Rental History Rental History Open Script Yesfter Noarter Helvetica Geneva Times Times New Roman Arial MS Sans Serif )=400 Cancel You did not enter any find criteria; all records will be displayed.C) Cancel No records match this request.E) wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! wwwwww ffffff UUUUUU DDDDDD 3333B """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST VDEFA( (LIST LISTAPComputers Office Furniture Tools - Hand Tools - Power Vehicles Miscellaneous VDEFA( (LIST LISTA Don't Count Weekends VDEFA( A Item ListB Category ListC Don't Count Weekends List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww "%UR UD33D AD@D@ AD@D@ B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" bRBBP0 @@BA@ JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+N &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$! 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.R 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,0V 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,Z *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21 .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww computers